package com.prelearning.at_springboot.mapper;

import com.prelearning.at_springboot.entity.Published;
import com.prelearning.at_springboot.entity.Unpublish;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author cgr
 * @since 2022-04-10
 */
public interface UnpublishMapper extends BaseMapper<Unpublish> {

    //根据群主id获取未发布签到,按发布的时间倒序
    @Select("SELECT * FROM unpublish WHERE user_id=#{owner_id} ORDER BY creat_time DESC")
    List<Unpublish> getUnpublish(String owner_id);

}
